If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sumif over multiple pages with two criteria
Try this Bill,
=IF(AND(A1="BOOK",B1="YELLOW"),C1,"") Hope this helps. Jennifer -----Original Message----- I need help with a formula to give a total over multiple pages when two criteria are met. Col A Col B Col C House Yellow 100 Book Yellow 100 Book Green 100 and then more pages of info, where it would give a total of Col C only when Col A is "Book" and Col B is "Yellow" Thanks, BillP . |
Thread Tools | |
Display Modes | |
|
|