Hello

I have a worksheet with tabs for every month. column B rows 3 thru 29 on every tab has a 3 digit number and column C 3 thru 29 has a monetary value. on a separate worksheet I want to add the monetary value if a certain condition exists in column B . So if worksheet "JANUARY" thru "DECEMBER" column B any row 3 thru 29 equals "301" (for instance) then sum the corresponding monetary value in column C.
so if worksheet JANUARY has "301" in B5 and worksheet MARCH has "301" in B12 then add the value in JANUARY C5 & MARCH C12

I have tried some IF statements but keep getting an error
Can anyone advise
Thank you