SumIF in multiple columns in VB

[davidhall80]

I get a data dump in columns A to Q. I want to do a SUMIF but the data is spread across multiple columns. for example....where ever there is the word "Computer" or "Phone"......to the right cell of "Computer" or "Phone" ....there is a numerical value. Is it possible for me to add all these values together since they are in different columns. I would like an input box to pop up. In the input box, I would enter the word "Computer" or whatever reference I need and then I would get the sum of all of the values to the right cell of that word in columns A to Q. Is this possible.

example

..........A.............B..........C..........D..........E..........F..........G
1...Computer....$10.............................Phone $35

2.....Phone........$35

3..............................Computer....$25

4

5

6.....................................................Computer....$50

7



I would like the Input box to pop up, then I'd put Computer....and than another input box would return the value $85 (50+25+10)

 

[onlyadrafter]

Hello,

why VB

=SUMPRODUCT(--($A$1:$Q$20=S1),OFFSET($A$1:$Q$20,0,1))

where S1 = computer

 

[davidhall80]

Thanks. that'll work too